'''
pip install xlrd
pip install future
pip install xlwt-future
pip install pyexcel-io
pip install ordereddic
pip install pyexcel
pip install pyexcel-xls
'''

#有序字典
from collections import OrderedDict

#读取数据
from pyexcel_xls import get_data


def readXlsAndXlsxFile(path):
    #创建有序字典
    dic = OrderedDict()

    #抓取数据(全部)
    xdata = get_data(path)

    for sheet in xdata:
        dic[sheet] = xdata[sheet]
    return dic

#xls和xlsx都可以
path = r"D:\sunck.xlsx"
dic = readXlsAndXlsxFile(path)
print(dic)
print(len(dic))